package com.example.demo.easyexcel.db.entity;

import java.io.Serializable;
import javax.persistence.*;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;


/**
 * @Author zjq
 * @Date 2024/06/24 09:48 
 */

@ApiModel(value = "滨江中小学体测数据")
@Data
@Entity
@Table(name ="physical_fitness_test")
public class PhysicalFitnessTest implements Serializable {

	private static final long serialVersionUID = 3823074004822807777L;

	@ExcelIgnore
	@ApiModelProperty(value = "主键")
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
   	@Column(name = "id")
	private Long id;

	@ExcelIgnore
	@ApiModelProperty(value = "学校id")
   	@Column(name = "xxid")
	private Long xxid;

	@ExcelProperty(index = 0, value = "学年")
	@ApiModelProperty(value = "学年")
   	@Column(name = "year")
	private String year;

	@ExcelProperty(index = 1, value = "年级编号")
	@ApiModelProperty(value = "年级编号")
   	@Column(name = "grade")
	private String grade;

	@ExcelProperty(index = 2, value = "班级编号")
	@ApiModelProperty(value = "班级编号")
   	@Column(name = "classnum")
	private String classnum;

	@ExcelProperty(index = 3, value = "班级名称")
	@ApiModelProperty(value = "班级名称")
   	@Column(name = "classname")
	private String classname;

	@ExcelProperty(index = 4, value = "学籍号")
	@ApiModelProperty(value = "学籍号")
   	@Column(name = "grbsm")
	private String grbsm;

	@ExcelProperty(index = 5, value = "民族代码")
	@ApiModelProperty(value = "民族代码")
   	@Column(name = "mz")
	private String mz;

	@ExcelProperty(index = 6, value = "姓名")
	@ApiModelProperty(value = "姓名")
   	@Column(name = "xm")
	private String xm;

	@ExcelProperty(index = 7, value = "民族")
	@ApiModelProperty(value = "性别")
   	@Column(name = "xb")
	private String xb;

	@ExcelProperty(index = 8, value = "出生日期")
	@ApiModelProperty(value = "出生日期")
   	@Column(name = "csrq")
	private String csrq;

	@ExcelProperty(index = 9, value = "学生来源")
	@ApiModelProperty(value = "学生来源")
   	@Column(name = "xsly")
	private String xsly;

	@ExcelProperty(index = 10, value = "身高")
	@ApiModelProperty(value = "身高")
   	@Column(name = "sg")
	private String sg;

	@ExcelProperty(index = 11, value = "体重")
	@ApiModelProperty(value = "体重")
   	@Column(name = "zt")
	private String zt;

	@ExcelProperty(index = 12, value = "肺活量")
	@ApiModelProperty(value = "肺活量")
   	@Column(name = "fhl")
	private String fhl;

	@ExcelProperty(index = 13, value = "五十米跑")
	@ApiModelProperty(value = "五十米跑")
   	@Column(name = "wsmp")
	private String wsmp;

	@ExcelProperty(index = 14, value = "立定跳远")
	@ApiModelProperty(value = "立定跳远")
   	@Column(name = "ldty")
	private String ldty;

	@ExcelProperty(index = 15, value = "坐位体前屈")
	@ApiModelProperty(value = "坐位体前屈")
   	@Column(name = "zwtqq")
	private String zwtqq;

	@ExcelProperty(index = 16, value = "800米跑")
	@ApiModelProperty(value = "八百米跑")
   	@Column(name = "bbmp")
	private String bbmp;

	@ExcelProperty(index = 17, value = "1000米跑")
	@ApiModelProperty(value = "一千米跑")
   	@Column(name = "yqmp")
	private String yqmp;

	@ExcelProperty(index = 18, value = "一分钟仰卧起坐")
	@ApiModelProperty(value = "一分钟仰卧起坐")
   	@Column(name = "yfzywqz")
	private String yfzywqz;

	@ExcelProperty(index = 19, value = "引体向上")
	@ApiModelProperty(value = "引体向上")
   	@Column(name = "ytxs")
	private String ytxs;

	@ExcelProperty(index = 20, value = "一分钟跳绳")
	@ApiModelProperty(value = "一分钟跳绳")
   	@Column(name = "yfzts")
	private String yfzts;

	@ExcelProperty(index = 21, value = "往返跑")
	@ApiModelProperty(value = "往返跑")
   	@Column(name = "wfp")
	private String wfp;

}
